UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UG1faVfyg8hvi0+dYyqbAX9dkcWZ/2AO1REhiAiOjok='
WHERE
key_id = 'ae89ff6b8acd84a941217bdb2bd2d06640328f7e5af92a5dac0e2f243a24baed'
AND (
token = 'UG1faVfyg8hvi0+dYyqbAX9dkcWZ/2AO1REhiAiOjok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)