UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '197LB3sDK8YGyZYShXkz/vdDjIZJNhMs/wYoGU/0zcQ=' 
WHERE 
  key_id = 'fe18d74e708e2b6d271130e737185bb5c03ac40803ad154f1608f52f8dcd7d08' 
  AND (
    token = '197LB3sDK8YGyZYShXkz/vdDjIZJNhMs/wYoGU/0zcQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022