UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'haLiWyQj1N9v/4s5Mem69VrZWoYpcNmeIpl3OSrWIIA='
WHERE
key_id = 'bd6f69f813a76ce97a6eb6591c69e94cedfc31abf5c90a49d8c31afa83ffbfa8'
AND (
token = 'haLiWyQj1N9v/4s5Mem69VrZWoYpcNmeIpl3OSrWIIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)