UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X+cjXBX5JVIO+VkTYYqA7vX+pnFNcx5zP6/A6sbWMI8='
WHERE
key_id = 'b654c966dcb7a6f56a9e9a4cd966a1690c077b06c173c38fe21959d45a62be5f'
AND (
token = 'X+cjXBX5JVIO+VkTYYqA7vX+pnFNcx5zP6/A6sbWMI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)