UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mdrxdOgM+iEwVoG/zXcKs/4uBT7gPrNbf65LR9VOv3k='
WHERE
key_id = 'd427ec58467f9b22331e9eafe2701215c5bf680d2a6d076bbe0f31b2cbc3ca6f'
AND (
token = 'mdrxdOgM+iEwVoG/zXcKs/4uBT7gPrNbf65LR9VOv3k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)