UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D1cIkNocN8MAHCGvnh0bBjogSPKO+MOVf2aCfEHWQp4='
WHERE
key_id = 'aa49397a9451e252057362d0a20955419ddf84b5325266b3e5e06c9aed658a5f'
AND (
token = 'D1cIkNocN8MAHCGvnh0bBjogSPKO+MOVf2aCfEHWQp4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)