UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'tt4RHDyv1znmzIkRwe4T4irtOK9arDpYAiy/HQLes2M=' 
WHERE 
  key_id = '82d8a9a505a1ef14bc52b2cdd8b14aabd2aa121634f69f43ddb3c4fb7f1c5e5d' 
  AND (
    token = 'tt4RHDyv1znmzIkRwe4T4irtOK9arDpYAiy/HQLes2M=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029