UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6tIWwA6zOPVJVo3wkE9yy/8v2Egd+vwgQTlitAKlp0k='
WHERE
key_id = '0f554489dde95488ab12b6df95f6ae64a0b67997b1cb31a5983b3d124fdc7ee3'
AND (
token = '6tIWwA6zOPVJVo3wkE9yy/8v2Egd+vwgQTlitAKlp0k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)