UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z7LATuWbdljKuVoPhKCh/2Id0aufMsHKUBcsv9RISYY='
WHERE
key_id = 'd3935499f2e371fa53ebf66f04a19ba358947444fb2e5b6c61e73bc4900d9f39'
AND (
token = 'z7LATuWbdljKuVoPhKCh/2Id0aufMsHKUBcsv9RISYY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)