UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L/VJgYlv5bJy58ry1gdTUpcF/pIa/6zjZHYv8hCTHww='
WHERE
key_id = '690d7b4d7961874ba34c178308a2b81524038502299103e39a3fd8718f73b4ba'
AND (
token = 'L/VJgYlv5bJy58ry1gdTUpcF/pIa/6zjZHYv8hCTHww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)