UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oQj4GJehuslinqzMZsS4v7NWnB9skpmAJqDdFrPSufE='
WHERE
key_id = '31b85a11a77bf24e6bd1628b7078c6b85dd29fccd2e07c40b17bd2b3f277cad5'
AND (
token = 'oQj4GJehuslinqzMZsS4v7NWnB9skpmAJqDdFrPSufE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)