UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'dT25wztoLv45bsRTgO+k8Vb2Rz5n9aLcdW0497+t6nY=' 
WHERE 
  key_id = 'c17e1091e73721afc763a384c9b3d7ca760ce5ce4970c969a353f4af44bdce31' 
  AND (
    token = 'dT25wztoLv45bsRTgO+k8Vb2Rz5n9aLcdW0497+t6nY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047