UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'aEzW10K0mUVz9nlm8LSFv+Q7PEm8FrQLZJyrhooWPlE=' 
WHERE 
  key_id = '4198d245db34b2e78fe1caa0c0ce961335b416526fedb62a8299b1fb2e59c37f' 
  AND (
    token = 'aEzW10K0mUVz9nlm8LSFv+Q7PEm8FrQLZJyrhooWPlE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032