UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5+JXgvovcsklYL05n4IBoiojqsnJlcVNfhSNKHwSoos='
WHERE
key_id = '6b604adbcd9d73fb549eb0521d317b4bc113d7f83b2c90b4a56650f1e3d9ad10'
AND (
token = '5+JXgvovcsklYL05n4IBoiojqsnJlcVNfhSNKHwSoos='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)