UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'auVRMu4L4z3TMN0P5996y3bqHpW3KeO/fT3rKPkxEJY=' 
WHERE 
  key_id = '8b193724eb1b3c1cd247f86884889a670f3a5fe63c3aeb54e33a193b4ba9146c' 
  AND (
    token = 'auVRMu4L4z3TMN0P5996y3bqHpW3KeO/fT3rKPkxEJY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00067