UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'oGXNHcCMC4xCEL6uPcpG5vP9SPaE3gMQvavm4onXyIY=' 
WHERE 
  key_id = '2a4b135ba8a9f0d80415a87f6c393c64c292e09a643b712f6f40e24eebd40d43' 
  AND (
    token = 'oGXNHcCMC4xCEL6uPcpG5vP9SPaE3gMQvavm4onXyIY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037