UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xV2uU0QJ7PqCl2vkjXW1jCR+EaTVUfbzus+0Vo6W1mI='
WHERE
key_id = '165d0e3dab8e0eaa12079ac6a181ffe4dd89fe85aeafb770a52b4e22e7b47ca0'
AND (
token = 'xV2uU0QJ7PqCl2vkjXW1jCR+EaTVUfbzus+0Vo6W1mI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)