UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MiqKD8Q3oiqBKo0Eo5rluzzLoi0Soq19Vmy2CEFjnb4='
WHERE
key_id = '7517da6fbebcf4149f3d58f9fb192a8213d8b4e2a86a8d847874baf8e27a95a4'
AND (
token = 'MiqKD8Q3oiqBKo0Eo5rluzzLoi0Soq19Vmy2CEFjnb4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)