UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'm6LC2n2boHJHQIaM9nmqicVEEMwsI576ddMlwgG2gQ8=' 
WHERE 
  key_id = '657c46ebe93486da0953473419961866513a9bf746b764010169ff6e5e7d7cfb' 
  AND (
    token = 'm6LC2n2boHJHQIaM9nmqicVEEMwsI576ddMlwgG2gQ8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031