UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CMQBEbWGdyjARui7mwmVpXbLp/x9MoC94HP3qtQsg/w='
WHERE
key_id = '8a9f677df7fd783156cd96494314f188831586ed26a9f73b6e022cd0b5d73316'
AND (
token = 'CMQBEbWGdyjARui7mwmVpXbLp/x9MoC94HP3qtQsg/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)