UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/UwwA+QgeK64ood+mLBD0P5BqquuPK6Dnbce1AjYFA4='
WHERE
key_id = 'c256bc94b900b5ee1a263e699a58d34f9c5def42b7a3891ce8993aacc3c18342'
AND (
token = '/UwwA+QgeK64ood+mLBD0P5BqquuPK6Dnbce1AjYFA4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)