UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8z02AnEHYWmsmWyfxSoagOkpwANvYz0GRmfXFN2Fdw8='
WHERE
key_id = '996c9aaee213b2ffc50d5cec0420ed0df00a397a3572e4710f6005c19a8597ce'
AND (
token = '8z02AnEHYWmsmWyfxSoagOkpwANvYz0GRmfXFN2Fdw8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)