UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Ph1b0YeS4JRQ4lDMn6Jp80nYmmIubBBfN1Uf3ACKKfs=' 
WHERE 
  key_id = '12a10ac1c9d13695cf8f4e3a922bf79fb10af8b2616c7e34fb3d7af646a892dc' 
  AND (
    token = 'Ph1b0YeS4JRQ4lDMn6Jp80nYmmIubBBfN1Uf3ACKKfs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032