UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CsrW5rWPhNu7kkWuHUszaAf9URZNQEir/mYyFZgPxHQ='
WHERE
key_id = '829a3d546c00faebcdedc35ca1cd43be87b4d1d3f75f537273e81a06d70db517'
AND (
token = 'CsrW5rWPhNu7kkWuHUszaAf9URZNQEir/mYyFZgPxHQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)