UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TCL7crN0UTsZL5W+KrmrYvdju4hcFSJu9Ajkz1eZR74='
WHERE
key_id = '8240f440129c1769d8195141b2121532b50b5c6aa8ee7175e457f94b7bad7ed2'
AND (
token = 'TCL7crN0UTsZL5W+KrmrYvdju4hcFSJu9Ajkz1eZR74='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)