UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5tXotMtCUButptE4/1tVGywiRj60IuGOUKnX6/tCqGU='
WHERE
key_id = 'ef412088a1dbc52f57656ad2cedd8e245b18c08f069b28ef4033e609c0a1ac1a'
AND (
token = '5tXotMtCUButptE4/1tVGywiRj60IuGOUKnX6/tCqGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)