UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1LHO+8ZHJ8q7UuQrmJ4G6sV00nrkN6x4TYxp8a+miUY=' 
WHERE 
  key_id = 'ec4a6ec93b6cc87b5a9b8dd687b749a26ea4133e34ecf48345aad6349c61b05c' 
  AND (
    token = '1LHO+8ZHJ8q7UuQrmJ4G6sV00nrkN6x4TYxp8a+miUY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030