UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xZ83taMKRieQO+ZFJEWVS+NPrM8MnMIqLCAjkKWzMKM='
WHERE
key_id = 'aa8573ff5b75ef3c64598ad445db78f549e3f9447311e663d3550f1af9b7e307'
AND (
token = 'xZ83taMKRieQO+ZFJEWVS+NPrM8MnMIqLCAjkKWzMKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)