UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '996S98kM2qdR6FaPi7VVVcXou2dU9I18eGin2nixrM8='
WHERE
key_id = '9712a94b979c32cd90ffe3be62aea92196ef8e2b6dc359107caf2ebfaa339244'
AND (
token = '996S98kM2qdR6FaPi7VVVcXou2dU9I18eGin2nixrM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)