UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZhBKY+KI+V8bSQC6oL46xwrMkhfp3qlZHJKkrba7ReA='
WHERE
key_id = '9cb2507410c4c417ceaa5d92544be4501cfb2567d4b34b117075482c8f63c68a'
AND (
token = 'ZhBKY+KI+V8bSQC6oL46xwrMkhfp3qlZHJKkrba7ReA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)