UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c8ydb9THOYlHQT3jD/z+uInL5Gse5ERi4C2XAig8nl0='
WHERE
key_id = '1e2c9e01e93b76b9f169d1d75c48f58e9a83f3774eeb08cec2dea634415e4eb0'
AND (
token = 'c8ydb9THOYlHQT3jD/z+uInL5Gse5ERi4C2XAig8nl0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)