UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0PX5sZJbYAlyAO2H0TVS7Q+mEFcv8hx6KU9Yz2o5CEk='
WHERE
key_id = '889a4b970f247c0ad5de28604627814740f3b33989423f70a8e9cd173ccba488'
AND (
token = '0PX5sZJbYAlyAO2H0TVS7Q+mEFcv8hx6KU9Yz2o5CEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)