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