UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'dkNxR2+2LtXik1Y2FCT54Zem84837t8HHcnBGh9eH30=' 
WHERE 
  key_id = '1d7fd7d9edf612f0bcac5a7718a3ab780e872d573bad02c7cb1a5c048636ed74' 
  AND (
    token = 'dkNxR2+2LtXik1Y2FCT54Zem84837t8HHcnBGh9eH30=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043