UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zvepHwFlBrXCAn7VE4jLIqiHzm+RK1h0zChx+izy/rU='
WHERE
key_id = '505698e9caa60d27a829bd4a317c7019827576c776fc038870f8769fbb6c978c'
AND (
token = 'zvepHwFlBrXCAn7VE4jLIqiHzm+RK1h0zChx+izy/rU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)