UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9X0G81Pmqg5nQebLi/rokjnM1vUFwR3p4kxHPOJOoCM='
WHERE
key_id = 'fee0842efb73485eb435a679f7400ef42b21c4a9ec321b361beae88535ce790b'
AND (
token = '9X0G81Pmqg5nQebLi/rokjnM1vUFwR3p4kxHPOJOoCM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)