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

Query time 0.00025