UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XGEmDomRA3VXwZjYoFgNhZZT2zBbaf+wb0U9RabBSs4='
WHERE
key_id = '1f22b874b9ac00be417a6e153e24283e5801eb3b30421fcbae1ac0dcddf78c94'
AND (
token = 'XGEmDomRA3VXwZjYoFgNhZZT2zBbaf+wb0U9RabBSs4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)