UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'gNB8Vy9NeAwiTo7MspHi1AkPV+yXY3ugPbBN5a/stuQ=' 
WHERE 
  key_id = '1d6ff9687bde4543a25bc94f4ce68df7f103cb474bcda60e49382a969e5f8323' 
  AND (
    token = 'gNB8Vy9NeAwiTo7MspHi1AkPV+yXY3ugPbBN5a/stuQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026