UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'crF9hLN1b5LpvZuY2I7HwazdESClA5NdoHpeBVbp/Gc='
WHERE
key_id = 'a4b8ab3ec7bf988f595f7b120fd4ff95293afe18dab88b48f3f83ce18a50643d'
AND (
token = 'crF9hLN1b5LpvZuY2I7HwazdESClA5NdoHpeBVbp/Gc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)