UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'h5I2nJrstjvq7Nw6FTwpWCv6hk7rXNmc00m03hkmybo=' 
WHERE 
  key_id = 'cbfc08446bf768beca9284374f3fb21166660fb1e2bbe1f20e4f373d12e31127' 
  AND (
    token = 'h5I2nJrstjvq7Nw6FTwpWCv6hk7rXNmc00m03hkmybo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040