UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8iJG1GTRt2dctvd36M1Q85TTbexbuF26bZbrMMIp3Mo='
WHERE
key_id = 'b12c675514a6bb71dee66891d2ef04d348f22417ae07a8d2e8fbb5823ee76abb'
AND (
token = '8iJG1GTRt2dctvd36M1Q85TTbexbuF26bZbrMMIp3Mo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)