UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9a1OEnjBlxasdOy2THO/AZ61T9wVBmsuYa3SVlyiPj0='
WHERE
key_id = 'f2bb7bd00fda207aee58a23be3ee29ae99e1437b7305b6b33ae49050697aaab4'
AND (
token = '9a1OEnjBlxasdOy2THO/AZ61T9wVBmsuYa3SVlyiPj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)