UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0BAyGa0AAc7bvGQeJS0H5km62jeAaORmI41p/J55hkc=' 
WHERE 
  key_id = '6c741a55d7eeb1b64a50efa016b71b52436d739519353e92f1bf4d4219cd0778' 
  AND (
    token = '0BAyGa0AAc7bvGQeJS0H5km62jeAaORmI41p/J55hkc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027