UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kzvlRyHyd1rRnzaxW2S01MTvCjskqJm7rFl2ph7gqYU='
WHERE
key_id = 'ccdeb400f0f3bd4647b474a809a4a89f7bc9a8e2136102977d36b10a9cf7906d'
AND (
token = 'kzvlRyHyd1rRnzaxW2S01MTvCjskqJm7rFl2ph7gqYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)